<?php
############## DIT STUK CODE ZORGT ERVOOR DAT JE ALS ADMIN INGELOGD MOET ZIJN OM DE PAGINA TE KUNNEN ZIEN ##############

    //Start de sessie
    session_start();

    //Load de benodigde bestanden
    require_once("includes/auth.php");

########################################################################################################################
?>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
	"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
  <title>Totaal Omzet</title>
  <link type="text/css" href="../css/pagination.css" rel="stylesheet" />
  <link rel="stylesheet" href="../css/reset.css" type="text/css" />
  <link rel="stylesheet" href="../css/960.css" type="text/css" />
  <link rel="stylesheet" href="../css/text.css" type="text/css" />
  <link type="text/css" href="../css/tablesorter.css" rel="stylesheet" />
  <link type="text/css" href="../css/pager.css" rel="stylesheet" />
  <link type="text/css" href="../css/sunny/jquery-ui-1.8.custom.css" rel="stylesheet" />
  <link type="text/css" href="../css/jquery.autocomplete.css" rel="stylesheet" />
  <link type="text/css" href="../css/style.css" rel="stylesheet" />
  <link type="text/css" href="../css/accmenu.css" rel="stylesheet" />
<script type="text/javascript" src="../js/jquery-1.4.2.min.js">
</script>
<script type="text/javascript" src="../js/jquery-ui-1.8.custom.min.js">
</script>
<script type="text/javascript" src="../js/jquery.tablesorter.js">
</script>
<script type="text/javascript" src="../js/jquery.tablesorter.pager.js">
</script>
<script type="text/javascript" src="../js/jquery.autocomplete.min.js">
</script>
<script type="text/javascript" src="../js/menu.js">
</script>
<script type="text/javascript">
$(document).ready(function()
    {
      $("#omzettable")
            .tablesorter()
            .tablesorterPager({container: $("#pager"), positionFixed: false});

    }
);
</script>

</head>
<body>
<div class="container_12">
<div id="header" class="grid_12">


</div>
<div class="clear"></div>
<div class="grid_12 spacer"></div>
<div class="clear"></div>
<div id="menu" class="grid_2">

        <?php
        include_once 'temp/menu_filler.php';
        ?>


</div>
<div id="adminarea" class="grid_10">
    <div id="tableholder">
<?php
include '../includes/connect.php';
// Connects to your Database

$weekomzet = mysql_query("SELECT vkprijs, aantal, UNIX_TIMESTAMP(factuur.datumtijd) as fdatum FROM factuurregel, factuur WHERE factuurregel.factuurid = factuur.factuurid ORDER BY datumtijd");


if (!$weekomzet) {
 exit('<p>Error retrieving data from database!<br />'.
  'Error: ' . mysql_error() . '</p>');
  }

echo "<h4>Totaal Omzet</h4>";

echo "<table class='tablesorter' id='omzettable' border='1'>";
echo "<thead><tr> <th>Datum</th> <th>Aantal</th> <th>Stuksprijs</th> <th>Factuuromzet</th> </tr></thead>";
echo "<tbody>";

while($row = mysql_fetch_array($weekomzet)){
  $vkprijs = $row['vkprijs'];
  $aantal = $row['aantal'];
  $factdatum = strftime("%d %B %Y", $row['fdatum']);
  $omzet = $vkprijs*$aantal;
  $weekont = $omzet + $weekont;

  echo    "<tr><td>".$factdatum;
  echo    "</td><td>".$aantal.
          "</td><td>&euro; ".number_format($vkprijs,2);
  echo    "</td><td>&euro; ".number_format($omzet,2)."</td></tr>";


}
echo "</tbody></table>";
echo "Totaal ontvangsten: ";
echo "&euro;$weekont";
?>
<center><div id="pager" class="pager">
            	<form>
            		<img src="../css/icons/first.png" class="first"/>
            		<img src="../css/icons/prev.png" class="prev"/>
            		<input type="text" class="pagedisplay"/>
            		<img src="../css/icons/next.png" class="next"/>
            		<img src="../css/icons/last.png" class="last"/>
            		<select class="pagesize">
            			<option value="5">5</option>
            			<option selected="selected" value="10">10</option>
            		</select>
            	</form>
</div></center>

    </div>

</div>
<div class="clear"></div>
<div class="grid_12 spacer"></div>
<div class="clear"></div>
</div>
</body>
</html>